<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
            "http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD>



<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<META name="GENERATOR" content="hevea 1.08">
<LINK rel="stylesheet" type="text/css" href="embroot.css">
<TITLE>
Using the SQL database interface
</TITLE>
</HEAD>
<BODY >
<A HREF="embroot060.html"><IMG SRC ="previous_motif.gif" ALT="Previous"></A>
<A HREF="embroot059.html"><IMG SRC ="contents_motif.gif" ALT="Up"></A>
<A HREF="embroot062.html"><IMG SRC ="next_motif.gif" ALT="Next"></A>
<HR>

<H2 CLASS="section"><A NAME="htoc118">11.2</A>&nbsp;&nbsp;Using the SQL database interface</H2>
The SQL database interface is contained in the dbi library.
<PRE CLASS="verbatim">
[eclipse 1]: lib(dbi). 
...
yes.
</PRE>
Your environment must be set up so that you can connect to a
database supported by lib(dbi). Normally a database administrator will 
have written a script to do this automatically. <BR>
<BR>
MySQL specific note: on some platforms, the MySQL client library is
provided as a dynamic load library (libmysqlclient.so in most Unix systems,
libmysql.dll in Windows systems). This file is
not provided with ECL<SUP><I>i</I></SUP>PS<SUP><I>e</I></SUP> distribution as it is part of the MySQL
system, and is covered by its own license. MySQL can be downloaded from 
<A HREF="http://dev.mysql.com/downloads"><TT>http://dev.mysql.com/downloads</TT></A>.
To successfully load the dbi library in such cases, you must have a version
of this library file that match the one that your copy of ECL<SUP><I>i</I></SUP>PS<SUP><I>e</I></SUP> was
compiled with, and in addition, ECL<SUP><I>i</I></SUP>PS<SUP><I>e</I></SUP> must be able to find this
library file when the dbi library is loaded. Normally, the person who
installed your ECL<SUP><I>i</I></SUP>PS<SUP><I>e</I></SUP> system should also make sure that ECL<SUP><I>i</I></SUP>PS<SUP><I>e</I></SUP> can
find this client library file using the normal way that the operating
system can find dynamic load libraries, e.g. by putting the file in a
standard system library location, or in the ECL<SUP><I>i</I></SUP>PS<SUP><I>e</I></SUP> dynamic library
directory for the platform in your ECL<SUP><I>i</I></SUP>PS<SUP><I>e</I></SUP> directory. On Unix systems,
it is also possible for the user to set an environment variable (usually
<TT>LD_LIBRARY_PATH</TT>) to point to where the dynamic library is.<BR>
<BR>
<HR>
<A HREF="embroot060.html"><IMG SRC ="previous_motif.gif" ALT="Previous"></A>
<A HREF="embroot059.html"><IMG SRC ="contents_motif.gif" ALT="Up"></A>
<A HREF="embroot062.html"><IMG SRC ="next_motif.gif" ALT="Next"></A>
</BODY>
</HTML>
